Chip 2004 April

home *** CD-ROM | disk | FTP | other *** search

/ Chip 2004 April / CMCD0404.ISO / Software / Shareware / Programare / golden / goldensetup57420.exe / {app} / Goldenhistory.txt < prev next >

Wrap

Text File | 2004-03-08 | 59.3 KB | 1,140 lines

Golden32 History: Version 5.7 Build 420 - March 8, 2004 . Added: New option "Don't backup workspaces" to stop Golden from keeping the three historical workspace backups *.bk1-*.bk3. . Fixed: In transposed mode it was possible for columns to be wider than the entire grid and therefore impossible to resize. Version 5.7 Build 419 - March 2, 2004 . Added: The ability to ignore columns in the source file when importing data using ImpExp (Golden's import/export tool.) Here are the instructions: This version adds a button with an 'X' on it that adds '-- IGNORE --' to the column list. You have to click the add button and then drag the IGNORE item to the correct position in the columns. The column list on the left side must have the same number of items as columns in the source file so you need IGNORE items for each column that you want to skip in the source file. . Improved: The keyword list has been improved with many more keywords. The keyword list in the options now only holds added keywords. You can also remove keywords by prefixing them with "-" (i.e. -SELECT) . Improved: The SQLBuilder now shows package/type methods as well as arguments. . Fixed: Describing packages with overloaded functions and procedures of the same name would cause an error message. . Fixed: Copying a row from the grid while in edit mode would include the ROWID. Version 5.7 Build 418 - November 17, 2003 . Improved: Improved the explain plan output and error reporting. Note that if you have 'Show explain plan as text' checked and use Oracle 9.2 it will show the output using the new dbms_xplan package. . Added: Added a new option called 'Show alternate unsaved indicator'. Checking this option causes the unsaved tabs to show a small circle on the lower right side instead of just turning the caption red (which was a problem for colorblind users.) This options is on the 'Tabs and Windows' page. . Fixed: Couldn't change the alignment of the last column in the spreadsheet. Version 5.7 Build 417 - October 3, 2003 . Improved: Improved object detail performance in the SQLBuilder when objects have a lot of constraints and indexes. . Improved: More detailed performance information in the connection diagnostics window. . Added: 'Copy Results' options now include 'Copy Titles Only (tab delimited)' and 'Copy Titles Only (comma delimited.) . Added: New right click menu when right clicking spreadsheet header columns. Now there are 'Align Left', 'Align Center' and 'Align Right' options. This cleans up the old toggle feature and allows us to add new 'column' level features in the future. . Added: New right click menu for the upper left spreadsheet cell with Autosize options (also on the standard spreadsheet right click menu and 'Results' menus.) New Autosize options for 'data and titles', 'data only' and 'titles only' without having to go to the options window. Version 5.7 Build 415 - September 23, 2003 . Improved: More performance information in the connection diagnostics. . Improved: Now using USER_CONSTRAINTS lookup when possible to help with performance problems in the ALL_CONSTRAINTS system view. If table object detail performance is slow and the cause is the constraint lookup contact us for a fix involving adding a new system data dictionary view. Connection diagnostics now gives a breakdown of the performance for object details. . Improved: SQLBuilder object list performance for large schemas. (i.e. pulling in 10,000 tables is now 2-3 times quicker in most cases.) . Improved: Improved object detail performance if setting "Column Information" is set to "Columns Only" . Improved: Window for prompt and pause messages now remembers its position. . Improved: Now doing a spreadsheet column autosize before showing the pause or prompt windows. . Fixed: NUMBER datatypes with no precision and 0 scale are now correctly shown as NUMBER(38) instead of just NUMBER in DESC and the SQLBuilder. . Fixed: NCHAR and NVARCHAR2 types will now show their correct length in DESC and in the SQLBuilder. . Fixed: Right clicking pk, fk, and index column headers in the object detail sqlbuilder window wasn't working if the window was horizontally scrolled. . Fixed: Error if SQLBuilder keyword list was empty. Version 5.7 Build 412 - August 15, 2003 . Added: The column detail list of the SQLBuilder will now show foreign key constraints. . Added: Right clicking a Primary Key, Foreign Key or Index column header in the object detail list of the SQLBuilder will show the DDL statement for that constraint or index. (i.e. right click the 'PK', 'FK', 'UX' or 'IX' header text.) . Added: You can now assign bind variable to prompt variables. REM Here's a cool example! REM Declare a bind variable. var BindSpoolFilename string; REM Run a pl/sql block that fills the bind variable with a filename including REM the current date. begin select 'c:\spoolfile'||to_char(sysdate,'yyyymmdd')||'.log' into :BindSpoolFilename from dual; end; / REM Define a prompt variable and set it to the value of the bind variable. define SpoolFilename = :BindSpoolFilename; REM Create a spool file with the computed name. spool &SpoolFilename; select * from tabs; spool off; . Improved: Showing column details (after clicking a table, view or synonym) in the SQLBuilder was not being run in a background thread. This has been fixed and should also be faster than earlier versions. . Improved: Optimized data dictionary queries used by the SQLBuilder. . Fixed: Headers and footers now work for printing SQL. . Fixed: Doing a find & replace of "\n" with "\r\n" (replacing a linefeed with a linefeed/carriage return pair) would cause a null character to get inserted in some cases. . Fixed: Error if var statement was used to redefine a cursor that was currently displayed in the spreadsheet. Version 5.7 Build 410 - July 17, 2003 . Fixed: Problems with printing transposed results. . Fixed: Problem with exporting large result sets to Excel if the user switched to Excel before the export was complete and changed active worksheets. Version 5.7 Build 409 - July 2, 2003 . Added: Cell detail window popup from the scratch results window. . Fixed: The scratch results window now shows moved columns correctly. . Fixed: The header font of the scratch window wasn't being set properly. . Fixed: popup menu on the scratch results window. . Fixed: Autorun from the favorites menu failures causing tab to lock. Version 5.7 Build 408 - June 26, 2003 . Fixed a problem with copying data out of the spreadsheet if columns had been moved. . Now transposed data can be exported to excel and csv files. Version 5.7 Build 407 - June 17, 2003 . Fixed a problem with the text viewer where it wasn't displaying various line break characters properly in the Text mode. Version 5.7 Build 406 - June 16, 2003 . Fixed a problem with handling different character sets in the editor and spreadsheet font settings. Version 5.7 Build 405 - June 12, 2003 . Spreadsheet Columns can now be re-ordered by selecting them and then dragging them to the new position. . SQLBuilder Changes: Added option called 'Single click keywords and columns' which is on by default. Turning this off makes it so that you must double-click keywords and columns in the SQLBuilder to paste them. This is better for people who use the keyboard instead of the mouse for the SQLBuilder and also cuts down on accidental pastes while just trying to scroll the various lists. This may become the default (double-click to paste) in the next version. Please let us know if you have strong opinions on this! Added option called 'Move focus to editor after paste'. This option is off by default. Improved keyboard handling for all SQLBuilder controls. . Added Shift-Arrow selection handling to the scratch window. . Improved Connection Diagnostics information. . Fixed situations where popup windows would display off the screen. . Fixed a problem where the SQLBuilder wouldn't work with default logins. . Fixed a problem with the spreadsheet scrollbar if 'clear on script run' was on. . Fixed a parsing bug with queries in edit mode containing ''. . Fixed a DESC[ribe] bug with spaces before the statement terminator. Version 5.7 Build 402 - May 7, 2003 . Fixed a problem where changing the font options wouldn't save as defaults. Version 5.7 Build 401 - May 6, 2003 . Fixed a problem where a parsing error could make a tab stop responding. . Fixed the SQLBuilder's search function so that searching will 'wrap' when it reaches the top or bottom. . Enabled incremental searching on the SQLBuilder trees. Version 5.7 Build 400 - May 5, 2003 . Added a 'Change Password...' item under the File menu. . Added support for TIMESTAMP, TIMESTAMP WITH TIMEZONE, INTERVAL YEAR TO MONTH, and INTERVAL DAY TO SECOND datatypes. . Greatly improved Golden's ability to run multiple long scripts without affecting each other. . Added Enter and Shift-Enter to the SQLBuilder searching keys (along with the up/down keys and buttons.) . Reduced the memory used by the option objects. . Reduced the memory used by datasets (and improved speed) . Vastly improved SQLBuilder with unlimited objects and much faster handling. . Changed keyboard control of SQLBuilder slightly. Use shift-arrows to move through object list without refreshing the column information when desired. . Fixed a problem where functions outside of packages would be DESCribed as procedures. . Fixed a problem when copying spreadsheet results when in transpose mode. . Fixed the problem where second instance would start when loading .sql file from Windows Explorer. Version 5.6 Build 387 - October 2, 2002 . Added the script statement "EXPORT EXCEL" which will export the current spreadsheet results to Excel. . Fixed a slow logon problem for databases with a large number of users. Version 5.6 Build 386 - September 18, 2002 . Fixed a problem where Golden wouldn't use the dba_ views for lookups. . Fixed a bug related to importing data containing multiple field qualifiers in a row. Version 5.6 Build 385 - September 10, 2002 . Fixed a parsing bug related to trailing '--' type comments on the delimiter line. . Fixed a problem with statements containing multiple single '&' prompt variables after a '&&' define of the same variables. (i.e.: select '&&fish', '&fish', '&fish' from dual;) Version 5.6 Build 385 - September 10, 2002 . Fixed a parsing bug related to trailing '--' type comments on the delimiter line. . Fixed a problem with statements containing multiple single '&' prompt variables after a '&&' define of the same variables. (i.e.: select '&&fish', '&fish', '&fish' from dual;) Version 5.6 Build 383 - July 23, 2002 . Added handling for changing your password if it has expired (Oracle 8+ feature.) . ImpExp will not allow importing if the DBA has set the users mode to READONLY. Version 5.6 Build 382 - July 2, 2002 . Added a 'Read Only' checkbox to the login window. Sessions marked read only can only run select and exec statements. Note that it is also possible for a dba or system administrator to force all users or specific users to read only mode. Please let us know if you would like this information. As always, the best way to enforce user rights is with Oracle's own grant/rights system. . Added a new 'Find in results' option to the Results menu. Note that currently the search goes left to right and top to bottom. More options to come! . Added support for the commands: SET FEEDBACK ON/OFF -- Turns off feedback in spool files SET HEADING ON/OFF -- Turns off column heading info in spool files. This is useful if you want to make a spool file of dynamically generated SQL statements. Here is an example: REM Script to create analyze table statements set feedback off set heading off spool c:\spool.txt; select 'analyze table ' || table_name || ' estimate statistics;' from tabs; spool off; REM And then execute the spool file using: REM @c:\spool.txt; . Fixed a problem opening files on machines with the Netware client installed. . Fixed a problem where select statements that started with an open parenthesis wouldn't parse correctly. . Fixed a problem where 'Find again' was disabled. . Fixed a problem where an open workspace would be mistakenly marked as modified. . Fixed a problem where it was possible to move 'pane splitters' so that they couldn't be moved again. Version 5.6 Build 375 - March 18, 2002 . Fixed a bug related to running statements that didn't return any records after setting the spreadsheet to transposed mode. . Added shift-keyboard selection handling back to the spreadsheet (accidently removed in an earlier update.) Now Shift-PageUp/PageDown/Home/End should work correctly. . Changed pasting into the spreadsheet during edit mode. When pasting into a single record the focused cell will not change. Whe pasting into multiple records the current cell will move to last record pasted but stay at the current column position. Version 5.6 Build 374 - February 20, 2002 . Fixed a very minor parsing bug. Version 5.6 Build 373 - February 14, 2002 . Changed the parsing so that it now allows white space or '--' style comments after the ';' at the end of an SQL statement (on the same line.) . Put back the hotkey options for Golden, PLEdit and Goldview on the Tools menu. Version 5.6 Build 372 - February 13, 2002 . Fixed a parsing problem with build 370 related to whitespace at the end of a script. . Fixed a problem where build 370 wouldn't allow edit mode on a synonym. Version 5.6 Build 370 - February 11, 2002 . New menu system and toolbars. Favorites menu will now scroll if it doesn't fit onscreen even for Windows 95. . Improved the DESC[ribe] command to include describing packages. . You can now edit queries containing more than one table. Note that you can only edit the columns from the first table in the FROM list. If the query results contain more than one column with the same name as a column in the edit table that the first one in the list will be used for that column. (Alternate wording: Be aware that if the results contain multiple columns with the same name that are in the edit table's column list then the first one in the result set will be used to edit that column in the edit table.) Columns that can't be edited are shown in red text. The edit table is now shown on the edit spreadsheet's toolbar. . Added 'Export to CSV' and 'Export to XML' to the Results menu. . Added the ability to login as SYSDBA or SYSOPER. To do it just add ' AS SYSDBA' or ' AS SYSOPER' to your login name. The Conn[ect] command also supports this. . Removed the 'Character Set' setting from the options. You can now set the character set of the editor and spreadsheet using the font 'script' settings on the font selection window. . Added the option 'Ignore this error for rest of script' to the error window. . Greatly improved the script parsing speed (noticeable on scripts > 5000 statements. . Added a 'Rename Tab' command to the popup tab menu. . Fixed a problem where user would be prompted to save workspace even if it didn't need saving (under certain conditions.) . Fixed problem with describing objects with dblinks containing '.'. . Fixed a problem with Tabs as Spaces and block indent. . Fixed a problem with clipboard operations on the find/replace windows. . Fixed a problem where spool to file data wasn't aligned properly. . Fixed a problem where you couldn't use the Page Setup window to change the spreadsheet print title unless you were viewing the print preview. Version 5.5 Build 363 Production - August 15, 2001 . Changed the Workspace saving so that it will create and maintain three historical backups of the workspace file (named workspace.ext.bk#) Added a verify after write feature as well as a few other sanity checks. This is due to a user report of data loss in a workspace file. No bug has been found with the saving code but perhaps these changes will shed some light on the subject (it will help if a network glitch or something causes a workspace file loss.) If anyone has had problems with their workspace files please contact us at support@benthicsoftware.com! . Fixed a problem where the auto-reconnect feature wouldn't preserve the date format. Version 5.5 Build 362 Production - July 18, 2001 . Fixed a problem when pasting data into the insert row after already typing in some data on the row. . Fixed some problems with the export to Excel feature: . Text fields are now formatted as 'Text' in Excel instead of 'General' which would convert text that looks like a number (i.e. '0000' to 0) . Fields with data over about 800 characters would cause Excel to crash. Fixed by moving data containing large strings cell by cell which takes longer. Version 5.5 Build 361 Production - July 3, 2001 . Fixed the popup menu for the dictionary object tree on the SQLBuilder. Version 5.5 Build 360 Production - June 27, 2001 . Fixed a bug when using the SQLBuilder set for lowercase tablenames. Version 5.5 Build 359 Production - June 25, 2001 . Fixed some problems with editing tables with non-standard table/field names. . Fixed some problems with ImpExp related to tables with non-standard table/field names. . Added some new choices to the SQLBuilder right click menus. . Golden can now export data directly to Excel! Just use the 'Export current spreadsheet contents' menu item off the 'Results' menu. . Fixed a problem with the caret position when scrolling in certain conditions. . Fixed a problem where having a single or double quote in a comment might be flagged as an unterminated string. Version 5.5 Build 356 Production - April 26, 2001 . Now Golden will try to select a word at the current error position (if you have an error in your SQL statement.) . Added support for SPOOL and SET ECHO ON/OFF SQLPlus commands. SPOOL FILENAME Will copy results and timings to a text file. If the filename contains spaces enclose it with double quotes (i.e. SPOOL "C:\MY FILES\MY SPOOLFILE.TXT" SPOOL OFF Turns off spooling and closes the spool file. SET ECHO ON/OFF If ECHO is on then commands are placed in the spool file before the results. . Removed script error reporting for unsupported SQLPlus commands that can safely be ignored (i.e. BREAK.) Note that warnings for these commands will appear in the log. . Fixed a bug where the 'Use favorites directory as default directory' option wasn't working. . Fixed some parsing bugs with the '@' and 'START' commands. Note that you have to surround filenames with spaces with double quotes. i.e. @"C:\BENTHIC SOFTWARE\FISH.SQL" PARAM1 PARAM2 . Allow partial paths in @ or START commands i.e. @"SQL\FISH.SQL" PARAM1 PARAM2 will use current directory or favorites directory as root depending upon what setting you have for 'Use favorites directory as default directory' Note that current directory changes every time you load or save a file. Version 5.5 Build 352 Production - March 6, 2001 . Fixed a bug where only the last page of a print job would print if you choose to print a range of pages. Version 5.5 Build 351 Production - March 1, 2001 . Fixed a problem where running an explain plan would cause an error on the next script run. . Changed the SQLBuilder so that it can't interfere with queries running in public tabs (and vice versa.) . Fixed the table column lookup in the SQLBuilder to include the RULE hint. Version 5.5 Build 350 Production - February 20, 2001 . Fixed a problem where default column values wouldn't be used for inserts in editing mode. . Added 'read after insert/update' to editing mode so that you can instantly see what the record looks like after it gets posted to the database (it may have been affected by default values or triggers.) Please let us know if you find any problems with it! -- support@benthicsoftware.com . Greatly improved the ability of Golden to cancel running queries! . Added the ability to handle multiple REFCURSOR bind variables in a statement. Note that the refcursor displayed by default is the first one in the statement. . Added a menu called 'Results' which lets you clear the spreadsheet and to choose any REFCURSOR bind variable to view in the spreadsheet. Note that you can use the 'Show last query results' menu item to go back to the last query results after viewing a cursor. . Added a menu item called 'Connection Diagnostics' to show some information about the Oracle client and database. Version 5.5 Build 347 Production - January 24, 2001 . Fixed a bug in Build 346 which removed support for the commands SET ROLE, SET TRANSACTION, SET CONSTRAINT(S) . Got rid of the screen flash when creating and switching tabs. Version 5.5 Build 346 Production - January 18, 2001 New Features: . Golden will now allow you to edit multi-byte character set databases (like UTF-8.) . Completely rewritten printing system. . Improved print preview to include headers/footers for text and spreadsheet. . Added new 'Print line number' option for SQL printing. . Allow printing of page ranges and selected code. . Cleaned up the DBMS_Output window and added an 'Enabled' switch. Removed the 'Reset' button (just click 'Enabled' twice.) . This version adds support for the following SQLPlus commands (with some caveats): ACCEPT: Currently ignores the 'format' clause and 'datatype' clause. DISCONNECT: This will return an error if the tab is public. PAUSE: Note that this command could put up a dialog box from a tab that you are not currently viewing. PROMPT: Note that this command could put up a dialog box from a tab that you are not currently viewing. SET SCAN OFF/ON: Turns off/on scanning for prompt variables '&, &&' Full support but this command is list as obsolete in the latest version of SQLPlus. Replaced by SET DEFINE ON/OFF SET DEFINE OFF/ON: Same as SET SCAN . Golden will now handle abbreviated commands for all SQLPlus commands. . New option to set file extension used for workspace files (on the 'File filters and extensions' page.) Now all file extensions used by Golden can be customized! . Can now set the file extensions of files that will appear in the Favorites Menu. . The favorites menu can include directory shortcuts, so you can put a shortcut to another directory (say, on the network) in your favorites 'tree' and the files in the directory that the shortcut points to will be included on your favorites. Fixes: . Fixed a problem with SQLBuilder's primary key display. . Lots of improvements to the way workspaces are handled. . Fixed a problem where choosing to replace the current sql when using the SQLBuilder would remove the undo information from the editor. Version 5.5 Build 342 Production - November 15, 2000 . Added an option to limit the size of BLOB (and LONG RAW) data (default is to not retrieve any BLOB data. . Added the ability for ImpExp to handle BLOB (and LONG RAW) data (data is converted to HEX strings.) . Fixed a rare problem with number() datatypes giving a 'data was truncated' error. . Fixed a problem updating rows that contained full precision number values in edit mode. . Improved and optimized the SQLBuilder's primary key and index information query. Version 5.5 Build 340 Production - October 27, 2000 . Improved the text explain plan output so that plans will no longer be truncated. . Added an option called 'Use simple plan output' to show the 'old style' plan. If you don't have a newer version of the plan_table, you'll have to use the simple plan. . Added a new section to the help file that is all about the Explain Plan output! This section was graciously supplied by Keith Wood. . Fixed a bug where changes to the page options on the print preview window would not be used for printing. . Added an option called 'Remember SQLBuilder Open Status' to the SQLBuilder options. Checking this will make the SQLBuilder open on startup if it was open when the program was last closed. . Fixed a problem when 'explain plan' statements contained prompt variables. . Removed 'prompt' times (waiting for user input) from the script and statement timings. Version 5.5 Build 339 Production - October 16, 2000 . Fixed a printing problem where the footer text would be off the bottom of the page on some inkjet printers. . Added an option to the Tabs & Windows option page to allow the tabs to be 'stacked' (all the tabs appear on multiple rows instead of one scrolling row.) . Changed the 'Columns' list of the SQLBuilder to a listview showing column index, name, datatype, primary key and index information. Abbreviations are 'P' for Primary Key, 'U' for unique index and 'I' for nonunique index. There is a new setting on the SQLBuilder option page to specify what to show. You can click the column headers to sort (click the same one again to reverse sort.) . Added an option to the SQLBuilder option page called 'Only paste when Ctrl is down' If this is checked, you must hold the Ctrl key down when double- clicking a table, or single clicking a column to paste the text into the current SQL Tab. Version 5.5 Build 337 Production - October 4, 2000 . Now by default Tabs will be created to the right of the currently selected tab. This can be returned to the old setting (create new tabs at the end of the tab list) using the setting on the new Tabs and Windows option page. . Added the ability to reorder and rename tabs. Just right click in the tab and you will see a list of tabs that can be edited and ordered. You can drag and drop in the list or select one and click the up/down or edit buttons. . Modified the handling of pasted records into the spreadsheet in edit mode: . Fixed a very slow index column lookup query when starting edit mode. . Got rid of the 'You need to refresh the query to updated inserted records' restriction. If you insert a row and see the message 'Could not get ROWID after insert' please let us know (support@benthicsoftware.com) . Fixed a problem with pasting in records to the insert line when the SQL includes the ROWID (complained about data not fitting the # of cols.) . Removed the restriction on pasting in inserts that aren't complete records. . Allow you to paste inserts at any column position (used to force the first column to be selected.) . Added a new option to the Editor options page. The option 'Allow cursor past end of line' is checked by default. If you uncheck it, cursor movement will be more like Microsoft's code editing products. . Changed the 'Ignore Future Errors' checkbox on the error popup window to read 'Ignore errors (for this run)' to signify that it is a temporary setting that will reset at the next script run. Use the 'Ignore Errors' menu item off the 'Script' menu to turn off error reporting for this tab (stays until you close the tab or turn the setting off.) Also changed the display of the error window so that it won't give the continue option if you are just running one statement in a larger script. . Explain plan improvements. . Added an option called 'Show Plan as Text' on the general options page. If this options is checked then the explain plan shows as plain text. If not then the plan shows up in the spreadsheet. . Removed the restriction that the explain plan can only work on a script that has one statement (the plan will be for the statement at the current cursor position (similiar to 'Run single statement at cursor'.) . Updated the plan output using Oracle's example plan output script. . Modified the color settings on a number of the windows to use the standard system wide WindowsText color for fonts (it was using black which caused obvious problems if you used a black window background setting.) . Add Comment/Uncomment block command to the edit menu. This will add or remove '--' style comments from each selected line. Version 5.5 Build 330 Beta - August 28, 2000 . This beta release of Golden fixes a bug in build 329 that caused single statements to not run (unless they had a rem before them, doh!) . Added a single statement script to our test script list to catch this in the future. Version 5.5 Build 329 Beta - August 25, 2000 . This beta release of Golden is to fix an incompatibility with Computer Associate's Innoculate Antivirus software. . Added a 'Use alternate query for user list' option to the SQLBuilder. Checking this option will use a slower but more accurate query for the 'All Objects' user list. . Fixed a parsing bug related to REM inside a statement. Version 5.5 Build 326 Production - July 27, 2000 . Fixed a problem with the editor's right click menu. . Improved the script parser's handling of comments. . Added a way for companies to disable the password saving feature (send email for details.) Version 5.5 Build 325 Production - July 18, 2000 . Allow users to change the Open and Save dialog boxes file filter settings (Open/Save File Filters page in the options.) page in the options. . Decreased the amount of memory used by datasets a bit. . Fixed several minor sql parsing bugs. . Made the editors select colors match the current user's control panel color settings. . Fixed a display problem when a single line in the editor was over about 5000 characters (shouldn't happen very often!) . Fixed a problem with the favorites menu if the menu directory had spaces in it. . Fixed a problem with filenames with multiple '.' characters. Version 5.5 Build 324 Production - May 16, 2000 . Fixed a problem with the SQLBuilder where users with 'SELECT ANY TABLE' system privilege wouldn't see all the other object owners in the 'All Objects' pane. Version 5.5 Build 323 Production - May 8, 2000 . Added the ability to limit the number of records returned from select statements. The setting is on the General page of the Options window. You can also set the value by clicking on the middle 'status pane' that shows affected records. The status pane message will be red and say something like 'Select stopped after xxx records' if the limit was reached. . Improved Golden's READ ONLY mode. Run Golden in Read Only mode by starting it with -ro as a commandline parameter. There is also a registry key that you can set to force read only mode (email markford@benthicsoftware.com for details.) Read only mode removes the data editing feature and stops any sql statement except select and exec. Note that 'local' commands (like DESC) still run fine. . The CONNECT command will now default to the current private or public database (so you can leave off the @ part if you are already logged in.) Fixed a case where CONNECT wouldn't run unless you were already logged in. Version 5.5 Build 320 Production - May 1, 2000 . The undo/redo information was being cleared each time a script was run. This has been fixed. Version 5.5 Build 318 Production - April 27, 2000 . Fixed a display problem with the float datatype. . DBMS_Output window is properly reset when you re-login. . Added keyboard cell selection in the spreadsheet. (shift+arrows) . Now whenever a script is parsed Golden will trim any whitespace characters from the end of all lines. This should solve the 'invalid character' error when statements have spaces and such after the ';' character. . Fixed a problem where the footer text would be cut off on printouts to printers with wide non-printable margins. Version 5.5 Build 316 Production - April 13, 2000 . Fixed not being able to update records (in edit mode) when field names were longer than 26 characters. . Fixed an error message when setting the spreadsheet to transpose mode before running a query. . Fixed a number of problems with the login window's quick list popup menu actions. . Fixed the hotkey display on the popup menu for 'Close Tab' . Fixed accessing the file menu from a running tab. Version 5.5 Build 315 Production - April 6, 2000 . Fixed a problem where user would see a pl/sql error reported when running some types of queries (inline views.) . Fixed printing problems if you made paper size changes right before printing. Version 5.5 Build 314 Production - April 6, 2000 . Fixed a bug when compiling triggers. Golden would try to bind the :new/:old words. . Added Printer Settings button to the page settings window so that you can change the paper size and orientation. . Fixed a bug when describing partitioned tables. Version 5.5 Build 311 Production - April 3, 2000 . Mostly small bug fixes and changes from RC1. Version 5.5 Build 310 Release Candidate 1 - March 27, 2000 Lots of changes! Important notices: . Note that your font settings for SQL text and spreadsheet text will return to defaults when using this version. You will have to reset them in the options window. True type fonts print best! . We are now using a third party grid component instead of our homegrown one. The new grid is very powerful and will give us the ability for new features down the road. One big difference is that you must start with the mouse cursor at the left side of a cell in order to click and drag a multi-cell selection. The cursor will change slightly to indicate that you are in multi-cell selection mode. Printing: . Hugely improved page setup window. . Custom headers and footer on printouts. . Much improved printing with previews of both SQL and spreadsheet. . Ability to print spreadsheet without going through the preview screen. . Ability to print SQL with syntax highlighting or as plain text. Spreadsheet: . Selection changes: . You must click on the left part of a cell to start a multi-cell drag selection. . You may select multiple rows or columns. Use Ctrl-Click to select discontinuous columns or rows. . Edit mode changes: . Paste multiple records when editing (both update and insert) . Delete multiple records when editing. . Full editing of CLOB and LONG values (used to have a problem once longs got too big. . Proportional scrollbars. . View text viewer by double-clicking a cell (changed from Ctrl-Click) . Right click column header to change alignment. . Right click top-left spreadsheet cell (on header line) to autosize visible rows. Shift-Right click it to autosize all rows. SQL Editing: . SQL Error position now shown for Net8.0.x clients! . New bracket find and selection commands (Ctrl-B) . Search and replace enhancements. Interface: . Program Options menu item moved to Tools menu (like Microsoft's apps.) . Most recent files moves to bottom of file menu. . New print buttons on the toolbar. Connections: . Disconnect menu item (under login) to disconnect from all databases (allows leaving Golden running while database is restarted.) . Better error handling when session is killed or disconnected. Autoreconnect will be attempted (you will be notified since data may have been rolled back.) General: . Slightly less memory intensive. . Removed 'Update only changed fields' setting. It makes much more sense to only update changed fields (as all other tools do.) . Ignore Net8 option removed (not needed anymore!) Version 5.5 Build 302 BETA - January 6, 2000 Fixed a bug where Golden would incorrectly detect bind variables inside string literals. Version 5.5 Build 301 BETA - January 4, 2000 Added 'How to' sections to the online help for: 'How to use prompt variables' and 'How to use bind variables'. Added more support for Bind variables. They work very much like the SQLPlus Bind variables. Please see the online help section 'How to use Bind variables.' to learn more. The Exec command now properly runs on a background thread. Some minor Editor speed improvements. When editing records with long floating point decimal places Golden would complain that another user had changed the record and disallow the edit. Fixed. Added Ctrl-[ and Ctrl-] hotkeys which find the next matching bracket character. Sort of like a single character find feature, but for brackets it will find the matching one. Version 5.4 Build 299 - December 6, 1999 Fixed the Copy commands for the spreadsheet when it is set for transposed mode (right click spreadsheet for this option) Fixed the Scratch Spreadsheet window to work correctly when the source spreadsheet is transposed. Version 5.4 Build 298 - November 29, 1999 Fixed a parsing error with REM and EXEC statements. DESC now shows REF CURSOR types correctly. Added the ability for the exec command to process functions that return a ref cursor type variable. The function must be run with a bind variable called :cursor. For example: exec :cursor := MyCursorFunct('Fish'); or exec MyCursorProc('Fish', :cursor ); -- Second argument must be an in/out ref cursor type. Version 5.4 Build 295 - October 27, 1999 Fixed a bug displaying the 'All Objects' tab of SQLBuilder. Added an error message to ImpExp for when the destination table doesn't exist. Version 5.4 Build 294 - October 12, 1999 Fixed a bug displaying negative numbers when the datatype was number(1). Version 5.4 Build 293 - October 11, 1999 Changed the default setting for 'AutoRun' in the Favorites menu to False which seems to be the more popular setting. Fixed a problem with restoring the main window position if it was maximized when closed. Fixed a problem with the 'Export current query' command. Changed the All Objects window of SQLBuilder to make it much faster. Fixed a right clicking problem in SQLBuilder. Reduced the number of system resources Golden uses per 'tab'. Added a 'transpose columns/records' choice to the spreadsheet's right click menu. Added a 'select other users' choice to the SQLBuilder's User tab's right click menu. This may be useful in some situation where a user has access to many different schema's objects. Some changes to the login window to remove duplicate quicklogin entries. Added options to uppercase/lowercase the SQLBuilders keywords and object pastes separately. Added an edit menu choice to toggle the case of selected text. Version 5.4 Build 284 - August 2, 1999 Fixed a bug where focus would shift to another program when closing the find or replace windows. Fixed a bug where the text selection would be lost when right clicking the editor. Version 5.4 Build 283 - July 20, 1999 Fixed a syntax highlighting bug. Version 5.4 Build 282 - July 19, 1999 Fixes a problem when using the Tools menu to go to other app when a hardcoded oci.dll is used. Golden now remembers the last directory used (if not set to use the favorites menu as the default directory.) The Tools menu will now work when the applications are in different directories. Note that the individual apps have to be run once 'solo' so that their locations can be entered into the registry. Version 5.4 Build 281 - July 15, 1999 Fixed editing of tables with dblinks. Fixed a problem with desc and synonyms. Fixed problems where dbms_output and cell detail windows would be stuck on top of other windows while some operations were running (exec.) Mousewheel now scrolls faster. New help file. Version 5.4 beta Build 280 - July 7, 1999 Fixed the login options window when using 'large fonts'. Put the Ignore Net8 option on the Login Options window. This is mainly used to fix the problem where Net8.0-Net8.0.4 won't report sql error positions. Version 5.4 beta Build 279 - July 6, 1999 Fixed a bug where dates could be truncated on display if the length of the date string was increased after the first query. Improved the Net8 detection code for those system that have an OCI.DLL file that doesn't work. Also added a way to pick the correct oraxxx.dll for systems with a 'messed up' registry. Version 5.4 beta Build 278 - July 1, 1999 Fixed a potentially dangerous bug where a query using prompt variables would run even if the cancel button on the script variable window was pressed. Changed the version to 5.4 to make it obvious which version contains the above fix. Version 5.3 beta Build 276 - June 30, 1999 Improved Login window with new Options window. Added Ctrl-Right click to run a single statement at the click position. Added Mousewheel support. Put back 'Running SQL' lightning bolt icon on tab's statusbar. Note that you cannot click it to stop the run, use the stop button. Version 5.3 beta Build 274 - June 22, 1999 Better code for linking to SQLNet/Net8. Automatic support for multi-homed systems. Better error messages on link failure. Improved Cell details window. Fixed drag and drop of Workspace files on Golden. Added Workspace files to Most Recent Files list. - More to come! - Version 5.3 beta Build 270 - June 1, 1999 Added a HEX viewer to the cell details window. Changed an internal bind buffer that was causing problems. Fixed a problem with ImpExp32 related to default font size and screen dimensions. Version 5.3 beta Build 266 - April 14, 1999 Changes for Net8 8.1.x. Version 5.3 beta Build 265 - March 30, 1999 Fixed a problem with creating new tabs after closing all under some conditions. Version 5.3 beta Build 263 - March 26, 1999 Fixed some major problems with find and replace. Find and replace now are modeless and work on whatever tab is active. You can change tabs, type, etc. without closing the find/replace windows. Version 5.3 beta Build 261 - March 19, 1999 Made some slight parsing improvements. Changed the icon for ImpExp. Version 5.3 beta Build 259 - March 18, 1999 Fixed a problem with the SQLBuilder (nasty freeze up on large schemas.) Version 5.3 beta Build 257 - March 16, 1999 Enhanced the results printing to print the entire spreadsheet using multiple side-by-side pages if necessary (Finally!) Added a new option 'Workspace saves mark tabs as saved" that when checked will consider tabs saved to a workspace to be fully saved. Enhanced the DESC[RIBE] command to fully match SQLPlus. It can now describe remote objects (via db_links.) Fixed the undefine command (wasn't working!) Fixed a problem with blank prompt variables. Added a prompt variable cache so that if prompted for a variable name that isn't defined but has been used before, the default value will be the cached value. Added -a commandline switch to autorun a script on startup. i.e. c:\benthic\golden32.exe "-aC:\BENTHIC\MYSCRIPT.SQL" Example with autologon: c:\benthic\golden32.exe -uscott@mars -ptiger "-aC:\BENTHIC\MYSCRIPT.SQL" Added -x commandline switch to exit Golden automatically (used with -a) i.e. c:\benthic\golden32.exe "-aC:\BENTHIC\MYSCRIPT.SQL" -x (will run myscript and then exit.) Version 5.3 beta Build 252 - March 4, 1999 Fixed the 'startup tabs' setting. Changed the way that the SQLBuilder loads its data. (possible bug fix.) Changed the way that scripts run in the background. This change can make a slight visual problem with toolbar buttons that don't redraw their frame. I will work to solve this visual problem. Version 5.3 beta Build 251 - March 1, 1999 Fixed a script parsing bug when statements begin with a comment. Version 5.3 beta Build 250 - February 24, 1999 Fixes / Improvements: Fixed some editing bugs that could cause 'strange' characters to appear. Fixed performance problems with running large scripts. Editor should be faster and use less memory. Interface changes: Added line numbers to editor (off by default.) Added new Character Set setting in Options. Each tab has its own status bar. Cancel button is now on the tab status bar and only visible when running. Added undo / redo buttons to the toolbar. Added a 'quick search' field to the SQLBuilder. Added some 'right click' options to the scratch window. Shortcut changes: Ctrl-J: Login (also Ctrl-L) Shift-Ctrl-#: Sets a bookmark within a script. Ctrl-#: Goes to a bookmark. Alt-#: Switch to tab # (used to be Ctrl-#) Ctrl-PageDown: Next Tab Ctrl-PageUp: Previous Tab SQLBuilder QuickSearch: DownArrow, Enter: Search down. UpArrow, Shift-Enter: Search Up. Version 5.2 Build 243 - January 15, 1999 Added 'Unregister program' to the help menu. This is for consultants who register their copy at a site and want to unregister the program when they leave (much appreciated by the way!) Added a password prompt if a connect statement doesn't include a password. Changed double clicking so it will not select quote characters. Added options to the Options|Spreadsheet page to clear the spreadsheet before running scripts and statements. Removed the extra crlf from single cell spreadsheet copy. Fixed a cut/paste bug. Version 5.2 Build 242 - December 10, 1998 Improved the login window with the ability to save passwords. Just check 'Save Password' to have the password be saved (encrypted.) Double-clicking a line in the quick login list that contains a password will jump you right in. The setting of 'Save Password' is associated with each line in the quicklist. You should only have to change it when you are logging in for the first time on that account or if you want to change it after the first time. Note that the quicklist is now global across all of Benthic's tools (with the next releases.) Golden will now skip 'prompt' and 'accept' statements in the script. New 'Scan for Vars' option that will allow making the default to not scan for '&' variables. Fixed a problem where a tab caption would not be refreshed after a save. Version 5.2 Build 241 - December 7, 1998 Improved the login window to include a 'Quick Loginlist' of previous logins. I would like feedback on whether passwords should also (optionally) be saved (encrypted.) Send your vote to markford@benthicsoftware.com (Thanks!) Added a new 'Ignore Net8' checkbox to the login window so that you can choose to use the Oracle7 libraries even if Net8 is installed. This can be useful to avoid the Net8 bug that doesn't report error positions. Changed the way that the dbms_output window works. Now opening the window while on a private tab will open a new dbms_output window using that private session. Fixed a parsing problem with multiple internal comments containing a statement delimiter. Fixed problem with displaying '&' in the spreadsheet. Fixed a problem where the vertical scrollbar would go away when text was clipped at the top. Version 5.2 Build 240 - November 24, 1998 Fixed SET ROLE command. Version 5.2 Build 239 - November 18, 1998 Fixed a problem with updating and deleting records containing long fields. Version 5.2 Build 238 - November 18, 1998 Added '...' when text is clipped in the spreadsheet. Fixed problem with long columns being autosized so big that they couldn't easily be shown alongside other columns. Fixed a problem with Shift-Ctrl-Tab. Fixed a problem with parsing filenames for the @ function. Note that filenames with spaces must be surrounded by quotes: @"c:\program files\runme.sql" Version 5.2 Beta Build 237 - November 10, 1998 Fixed a problem with initialization of the keyword lists. Fixed some missing help links. Version 5.2 Build 236 - November 9, 1998 Added new Keywords page to the options for editing the keyword list. Added new SQLBuilder Wordlist page to the options for editing the SQLBuilder's word list. Added menu choice to check for a new version on the web and download it. Version 5.2 Build 234 - October 20, 1998 Added new save and load workspace commands. Right click the active tab to rename it. Some interface changes. Tabs can be at the top or bottom (Options) Added menu choice to check for new versions on the web. Added menu option to start ImpExp with the current select statement. Added code to strip out trailing line whitespace before parsing scripts. Added stored procedures to the DESCRIBE (DESC) command. Explain plan output now goes to a text screen. Use F12 to toggle spread, text, and log displays. Added the EXECUTE (EXEC) command. Bind variables are automatically scanned and displayed. Note that this doesn't support tables or refcursors yet. Note that exec'ed commands aren't currently being run in the background. (You can only run one at a time.) ImpExp Version 2.1 Build 104 - October 20, 1998 Fixed bug where cancel wasn't active during exports. Added some new options for the export header line. Made all checkboxes and radiobuttons in the program save their values when 'Save Defaults' is pushed. Version 5.1 Build 228 - Aug 12, 1998 Added code to load files opened from explorer into first instance. Changed version to reflect the public release of builds 225-228. Version 5.0 Build 227 - Aug 5, 1998 Fixed the commented out commandline file loading code. Version 5.0 Build 226 - Aug 3, 1998 New multi-level undo and redo. Editor scroll bars now work like a 'standard' windows edit control (scroll bars hide if not needed.) Fixed some small editor bugs. Version 5.0 Build 225 - July 30, 1998 Fixed a bug in the parser related to tables and fields with 'REM' in them. Added DESC command (=DESCRIBE) Added right click menu to the object trees in the SQLBuilder (currently used for pasting 'select * from table') Changed data editing so that you can edit tables without keys if you include the rowid as the first field in the select: eg: select rowid, bonus.* from bonus (where bonus has no PK or unique indexes.) Changed the way that the Favorites menu is displayed. This fixes a problem where the icons would disappear. Unfortunately this doesn't allow the 'opened folder' icon as you move over them (I really liked that!) Added a new option to the Menus Option page to set the default directory to be the favorites directory. Version 5.0 Build 224 - July 20, 1998 Changed updates to only update columns that were changed. There is an option to use the old behavior. Fixed autocommit. Fixed problem with comments inside strings. Fixed infinite loop when running a non-select from the favorites menu and option to disallow was on. Added new describe command (only for tables and views and local synonyms) ImpExp Version 2.0 Build 102 - July 9, 1998 Fixed problem with trailing nulls when not use a field qualifier. Version 5.0 Build 220 - June 26, 1998 Production New threading model that makes the interface more responsive. Fixed some problems with the most recently used file list. New improved @script running including step capability. Ctrl-Enter now does STEP (can be turned off in the Edit Options) During step cursor no longer has to be at the beginning of a statement. Fixed icon not showing in NT Tasklist. New version of ImpExp32 with help included. Version 5.0 Build 216 - June 8, 1998 Production Fixed problem with single quotes when deleting records. Version 5.0 Build 215 - June 2, 1998 Production Cleaned up File New/Open menus. Allow dragging of files from explorer. Added 'Visit Benthic Web Site' to Help menu New help system. Changed filename back to Golden32.exe Version 5.0 Build 210 - April 13, 1998 Beta 1.5 Many small fixes. Now allows changing tabs while editing. New Import Export program. The new ascii mode is much faster than the old one. Version 5.0 Build 209 - March 25, 1998 Beta 1.5 Added full autosize to Explain Plan display Added double quote processing for script filenames containing spaces. (eg. @"c:\program files\my script" Arg1 "Arg2 with spaces" Arg3 Added a display refresh when closing all tabs to show the tab in question. Fixed a bug where explain plan wouldn't go away. Added the following: Right click the upper left gray cell of the spreadsheet does an autosize (displayed rows only) Shift-Right click it to get a full spreadsheet autosize. Version 5.0 Build 208 - March 24, 1998 Beta 1.5 Fixed the 'Affected Records' display. Added a 'Hide before/after sql text' to the Options. Added a hotkey 'F8' to switch between editor and results (same as Ctrl-R) Added '.sql' to @files if the text has no extension. Version 5.0 Build 207 - March 23, 1998 Beta 1.5 Full Oracle8 relational support. Editor improvements and syntax highlighting speed increases. New sqlbuilder with better handling of case sensitive Oracle items. (cool 'qucksearch' by typing in the tree.) Better script parsing. New 'script stepping' feature (Run one statement at current cursor position.) New hotkeys for menu commands. New support for the '@' script running feature. New 'Private tab' ability. This allows a tab to have a private connection to the database. Please see the new help.txt file for details. Support for the SQLPLus CONNECT command. Version 5.0 Build 204 - February 25, 1998 Beta 1.5 Fixed problem with threading on Oracle 7.3.3. Version 5.0 Build 203 - February 17, 1998 Beta 1.5 Fixed Parsing problem with create or replace statements. Fixed problem with nested comments and parsing. Fixed problem with define statement 'hiding' the next sql statement in the script. Version 5.0 Build 201 - February 16, 1998 Beta 1.5 Fixed problem with dbms_output window crashes. Added back hotkeys Ctrl 1-0 for tabs. Added back noprompting option. Optimized script parsing. Fixed cancel button on prompting window. It now really cancels. Version 5.0 Build 200 - February 8, 1998 Beta 1 Many large and small changes. Here are some highlights: New user interface using dynamically created tabs. Significantly better threaded queries. Docked sqlbuilder window. Syntax highlighting. Unlimited size scripts and copy/paste Support for sqlplus style variable prompting. Language formated copy/paste (to copy sql to other programming environments) Editor supports deleting records. New Log window shows every command run and errors. New scratch results window for comparing data between tabs. New copy results to another tab (shift click the tab you want to copy result to.) New script parsing to match sqlplus parsing. SQL statements end with semicolon-return, plsql ends with return-'/'-return. Ability to turn off variable scanning and substitution. Ability to turn off errors before or during running script. Ability to run a script from the current cursor position. Version 4.6 Build 164 - December 1, 1997 Production release. Fixed exception while closing after not logging in. Version 4.6 Build 163 - November 17, 1997 Production release. Fixed a problem with the default date format. Version 4.6 Build 162 - November 14, 1997 Production release. Fixed a bug where explain plan wouldn't refresh. Version 4.6 Build 161 - November 11, 1997 Production release. Fixed an error while running an anonymous plsql block without a trailing '/' char. Version 4.6 Build 160 - November 5, 1997 Production release. Fixed a bug in the scripting engine that complained about trailing semicolons. PLSQL compile error indicated. Fixed bugs related to using the clipboard while editing. Can now abort editing a record cleanly. Version 4.6 Build 156 - October 20, 1997 Beta 2 Fixed a registration code bug! Version 4.6 Build 155 - September 29, 1997 Beta 2 You can now cancel a query by pressing <Esc> while it is running. Note that to cancel a query during the parse phase, you must have version 2.3 of sqlnet. Please report any problems! Version 4.6 Build 140 - September 10, 1997 Beta 1 Now each sql window shows its own results. Import/Export has been moved to a separate app that can be minimized while running. Right clicking a column header toggles between left, middle, and right alignment. Right clicking a cell shows the text in a modeless dialog that can wrap or show ascii codes. New most recent files on the file menu. Version 4.5 Build 124 - July 23, 1997 Added new statusbar pane to show what command was last executed and how many records it affected. Version 4.5 Build 123 - July 17, 1997 Greatly improved script parsing to allow comments. Cosmetic changes to error messages. Version 4.5 Build 118 - July 11, 1997 Editor improvements Home key toggles between beginning of line and first non-whitespace char. Tab and shift-tab indents/unindents selected blocks. Fixed problem with Tools Menu ignoring user options. Add version info and build number to about box. Started History file!